Step 1: Create “Time” Chart
a. Double click on the “Line and
Stacked column Chart" On the visualization bar.
b. Chart visual will display on the report.
c. Adds the fields to the Values well on the
visualization bar
· Drag and drop the "Month" column from
the Calendar table on the Shared axis.
· Drag and drop the "Year" column from the
Calendar table on the Shared axis.
· Drag and drop the "Weekdays" column
from the Calendar table on the Shared axis
· Drag and drop the "Holiday " column
from the Holiday table on the Shared axis.
· Drag and drop the “Sex" column from the
DUI_Fatalities table on the Column Series.
· Drag and drop the “Accident Per Day” column from
the DUI_Fatalities table on the Column Values.
· Drag and drop the “. YOY and %Fatalities " column from the DUI_Fatalities table on the Line Values.
Follow the gif below to create the “Time chart”.
Step 2: Configure “Time” chart
Click on the Format icon on the visualization bar
a. Click General Tab
·
Responsive:
On
·
X-
Position: 180
·
Y
Position: 116
·
Width:
586
·
Height:
315
·
Legend:
ON
·
position:
Top
·
Title:
OFF
·
Circle
Default Icon: on
Follow the gif below to format the “Time chart”.
b. Configure the X axis:
·
Color: Black
·
Text Size: 9
·
Font family: Segue UI
·
Minimum Catalogues width: 38%
·
Maximum size Categories :33%
·
Inner padding: 21 %
·
Concatenate labels: ON
· Title: OFF
Follow the gif below to format the X axis “Time chart”.
c. Configure the Y-
axis
a.
Y-axis (Column)
·
Position:
Left
·
Scale
type: Liner
·
Start:
-30
·
End:
140
·
Invert
axis: Off
·
Color:
Black
·
Text
Size: 9
·
Font
Family: Segoe UI
·
Display:
Auto
·
Value
Decimal Place: Auto
·
Title:
OFF
·
Gride
Line: On
·
Line
Color: Black (666666)
·
Stroke
Width: 1
·
Line
Style: Dotted
·
Show
Secondary: ON
·
Align
Zero: ON
b.
Y- axis (Line)
·
Position:
Right
·
Start:
Auto
·
End:
0.3
·
Scala
type: Liner
·
Color:
FF8900
·
Text
Size: 9
·
Font
Family: Segoe Ul
·
Display unit: Auto
Follow the gif below to format the Y- axis “Time chart”.
d. Configure Data Color:
· YOY: FF8900
· % Fatalities: 6EB7E4
· Female: EB00EB
· Male: 262A7
Follow the gif below to format the Data Color:
·
Color:
White (FFFFF)
·
Display
Unite: None
·
Value
Decimal: 1
·
Orientation:
Horizontal
·
Position:
Auto
·
Text
Size: 9
·
Font
Family: Arial
·
Show
Background: ON
·
Color :123D8F
·
Transparency:
53%
·
Customize
Serious ON
·
Select
“Female”
·
Show:
ON
·
Color:
White
·
Display:
None
·
Value
Decima Place: 1
·
Position:
Auto
·
Text
Size: 9
·
Font
Family: Arial
·
Show
Background: ON
·
Background
Color: 123D8F
·
Transparency:
53%
·
Total
Label: OFF
·
Title:
ON
Follow the gif below to format the Data Label “Time chart”.
f. Configure Shape,
Title, Background and Boarder
a. Shape
·
Shaded
area: ON
·
Stroke
Width: 1
·
Joint
type: Bevel
·
Line
Style: Solid
·
Show
Maker: OFF
·
Custom
Series: OFF
·
Plot
Area Transparency: 0%
b. Title:
ON
·
Type:
“Time”
·
Word
Wrap: ON
·
Font
Color: Black
·
Background
Color: ACD0E7
·
Alignment:
Left
·
Text
Size: 17
·
Font
Family: DIN
c.
Background: ON
·
Background:
white
·
Transparency:
15%
d. Border: ON
·
Color:
White 10% darker
Follow the gif below to format the shape, Title, Background
and Boarder “Time Chart”.
To learn More about Line and Stacked column charts, click the link below:
https://www.tutorialgateway.org/line-and-stacked-column-chart-in-power-bi/